package com.example.mapper;

import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 本文来演示
 *
 * @author 赵建云
 * @create 2023/10/12
 */
public interface DriverMapper {
    @Select("select pos_id from driver where js_id=#{value}")
    List<Integer> already(Integer jsId);
    @Select("select count(js_id) from driver where js_id=#{value} and dri_status=0")
    int driverNumById(Integer jsId);

    @Select("select count(js_id) from driver where js_id=#{value} and dri_status=1")
    int interviewNumById(Integer jsId);
    @Select("select pos_id from driver where js_id=#{value} and dri_status=0")
    List<Integer> driverSubmitByJsId(Integer jsId);
    @Select("select pos_id from driver where js_id=#{value} and dri_status=1")
    List<Integer> driverInterviewByJsId(Integer jsId);
}
